﻿CREATE TABLE [dbo].[FC_SalePrice] (
    [IdSalePrice] INT          IDENTITY (1, 1) NOT NULL,
    [IdCustomer]  INT          NULL,
    [IdProduct]   INT          NULL,
    [Value]       INT          NULL,
    [Currency]    VARCHAR (15) NULL,
    CONSTRAINT [PK_FC_PrecioVenta] PRIMARY KEY CLUSTERED ([IdSalePrice] ASC),
    CONSTRAINT [FK_FC_PrecioVenta_FC_Customer] FOREIGN KEY ([IdCustomer]) REFERENCES [dbo].[FC_Customer] ([IdCustomer]),
    CONSTRAINT [FK_FC_PrecioVenta_FC_Product] FOREIGN KEY ([IdProduct]) REFERENCES [dbo].[FC_Product] ([IdProduct])
);

